unit_id
// delete_flag = 0 AND work_status_code != 10
// valid_flag != -1
// approval_type_code = 1 or approval_type_code is null


// SELECT
// SUM(CASE WHEN t1.patrol_flag = 1 THEN 1 ELSE 0 END) AS patrolHumanNum,
//     SUM(CASE WHEN t1.patrol_flag <> 1 OR t1.patrol_flag IS NULL THEN 1 ELSE 0 END) AS assistHumanNum,
//     SUM(CASE WHEN t1.work_type_code IN (1, 2) THEN 1 ELSE 0 END) AS civilServantNum,
//     SUM(CASE WHEN t1.work_type_code NOT IN (1, 2) OR t1.work_type_code IS NULL THEN 1 ELSE 0 END) AS institutionNum,
//     SUM(CASE WHEN t1.support_type_code = 2 THEN 1 ELSE 0 END) AS thirdPartyNum,
//     SUM(CASE WHEN t1.support_type_code = 1 THEN 1 ELSE 0 END) AS coordinatorNum
// FROM law_human_extend_info t1
// LEFT JOIN law_unit_extend_info t3 ON t1.unit_id = t3.unit_id
// WHERE t1.delete_flag = 0 AND work_status_code in(1,4)
// AND FIND_IN_SET(t3.unit_uuid,'${com.egova.lowcode.foundation.util.UserSessionUtils::getSessionVariable("bd_var:9400dd20-fd28-473a-85d9-325d9e9e8dd1",false)}') > 0


// SELECT
// SUM(CASE WHEN t1.patrol_flag = 1 THEN 1 ELSE 0 END) AS patrolHumanNum,
//     SUM(CASE WHEN t1.patrol_flag <> 1 OR t1.patrol_flag IS NULL THEN 1 ELSE 0 END) AS assistHumanNum,
//     SUM(CASE WHEN t1.work_type_code IN (1, 2) THEN 1 ELSE 0 END) AS civilServantNum,
//     SUM(CASE WHEN t1.work_type_code NOT IN (1, 2) OR t1.work_type_code IS NULL THEN 1 ELSE 0 END) AS institutionNum,
//     SUM(CASE WHEN t1.support_type_code = 2 THEN 1 ELSE 0 END) AS thirdPartyNum,
//     SUM(CASE WHEN t1.support_type_code = 1 THEN 1 ELSE 0 END) AS coordinatorNum
// FROM law_human_extend_info t1
// LEFT JOIN sys_region t2 ON t1.region_id = t2.id
// LEFT JOIN law_unit_extend_info t3 ON t1.unit_id = t3.unit_id
// WHERE t1.delete_flag = 0 AND valid_flag != -1 AND work_status_code != 10
// AND t2.code like CONCAT('${com.egova.lowcode.foundation.util.UserSessionUtils::getSessionVariable("bd_var:fbbb29c8-c2a9-4eca-a78c-a732af6d119f",false)}','%')

// CONCAT('${com.egova.lowcode.foundation.util.UserSessionUtils::getSessionVariable("bd_var:fbbb29c8-c2a9-4eca-a78c-a732af6d119f",false)}','%')
